package com.lzb.provide;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * <h3>Description</h3>
 * TODO
 * <h3>Author</h3> Eric
 * <h3>Date</h3> 2017/10/20 11:57
 * <h3>Copyright</h3> Copyright (c)2017 Shenzhen TLKY  Co., Ltd. Inc. All rights reserved.
 */
public class SQLiteOpenHelperUtil extends SQLiteOpenHelper {
    /**数据库名*/
    private static final String DB_NAME = "DBStudent";
    /**表名*/
    public static final String TABLE_NAME = "GradeOne";
    public static String ID = "_id";
    public static String STUDENT_ID = "studentId";
    public static String MESSAGE = "message";
    public static String SQL = "create table if not exists GradeOne ( _id integer primary key autoincrement, studentId integer , message varchar ) ";
    public SQLiteOpenHelperUtil(Context context) {
        super(context, DB_NAME, null, 1);
    }

    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL(SQL);
    }

    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

    }



}
